Assign Server Roles
Description
The plugin is designed to give server related roles to the particular login user to perform server operations.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step Name | Name of the step. This name has to be unique in a single workflow. |
| Connection: | ||
| 2 | Server name | The IP address of remote machine on which MSSQL server instance is present should be given. |
| 3 | Instance name | The instance name of the MSSQL server should be provided. If we provide Instance name, Port number field will get disabled. |
| 4 | Port | The port number of the MSSQL server should be provided. If we provide Port number, there is no need to provide Instance name. Port number should only be an integer. |
| 5 | Username | The login username of MSSQL server to authenticate. |
| 6 | Password | Specify or select the password, as required. If the checkbox Accept Value as variable/static is selected, then the password field appears as a text box and accepts static or variable values. OR If the checkbox Accept Value as variable/static is not selected, then the password field appears as a dropdown in which you can select a field from the previous steps. |
| 7 | Other Connection Parameter | Specify multiple, semi-colon separated parameters other than the default connection parameters. Other connection parameters will be appended to the default connection parameters. Example of default connection parameters: Server Name, Password. Examples of other connection parameters: encrypt=false;trustServerCertificate=false |
| Button: | ||
| 8 | Test Connection | Verifies whether the connection is established or not. NOTE: Test Connection button does not work for Previous step fields. Test Connection button only works with static values and environment variables. |
| Input Tab | ||
| Input Fields: | ||
| 1 | Server Roles | Name of the Server Roles which is to be given to the user. This plugin is designed to assign single server role at a time. |
| 2 | Get Roles Button | Clicking on this button brings a dialog for the available Roles on that particular SQL server instance |
| 3 | Login Users | The login user on which the role is to be applied. |
| 4 | Get Users | Clicking on this button brings a dialog for the available Login Users on that particular SQL server instance |
| Output Tab | ||
| Output Fields: | ||
| 1 | Result | Output field to hold the result of the successful plugin execution. For step error handling refer Error Handling |